package com.javaweb.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.javaweb.admin.entity.KdlPurchaseinReturnB;
import com.javaweb.admin.entity.KdlZBFE;
import com.javaweb.admin.entity.KdlZBFEB;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface KdlZBFEMapper extends BaseMapper<KdlZBFE> {

    @Select("select isnull(convert(varchar(20),max(sync_time),120),'2024-03-28 00:00:00') from kdl_zbfe_b")
    String GetMaxSyncTime();

    @Select("select * from kdl_zbfe_b where pid=${pid} order by materialcode")
    List<KdlZBFEB> getZBFEDetail(Integer pid);
}
